package com.ruoyi.wvp.utils;

import java.util.Objects;

public class PermissionUtil {

    public static String getDeptAddressUnitSql(Long deptId) {
        if(Objects.isNull(deptId)){
            deptId=0L;
        }
        String s = "SELECT 	wdra.address_unit_id FROM 	sys_dept sd 	LEFT JOIN wvp_data_role_address_unit wdra ON sd.data_role_id = wdra.data_role_id WHERE	sd.dept_id = ";
        return s+deptId;
    }
}
